﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobj of eComProduct; merged into product" >
	<Sql>
		SELECT
			id,partId,supplierPartId,supplierId,
			avgCostPrice,listPrice,sellPrice,sellPriceDescription,
			weight as weight_amount,weightUnit as weight_unit,
			width as dimensions_width_amount,widthUnit as dimensions_width_unit,
			length as dimensions_length_amount,lengthUnit as dimensions_length_unit,
			depth as dimensions_depth_amount,depthUnit as dimensions_depth_unit,
			shippingBoxOption,
			pricingId, checkoutWizard
		FROM
			eComProducts
		WHERE
			id = @id;
	</Sql>

	<Param name="product.id" dbName="id" type="UniqueIdentifier"/>
</AdoNetDataAccess>